You cant specify target table Person for update in FROM clause

144

You can't specify target table 'Person' for update in FROM clause -

# WRONG 
UPDATE table SET a=value WHERE x IN
    (SELECT x FROM table WHERE condition);

# CORRECT (Add one more outer level of select query)
UPDATE table SET a=value WHERE x IN
    (SELECT * FROM (SELECT x FROM table WHERE condition) as t)

Comments

Submit

0 Comments

More Questions

mysql format date	mysql grant all privileges to a user	finding duplicate column values in table with sql
mysql format date	order by sql	mysql show all tables
get all table name in sql through php	mysql show tables in database	select count of distinct values sql
import database through command line	sql server substring	rename table sql
selecting name that contain certain word in sql	install sqlite3 python	select duplicates in sql
ERROR 2002 (HY000): Cant connect to local MySQL server through socket -tmp-mysql.sock (2)	alter table add foreign key mysql	mysql delete row
how to auto increment in sql	how to install mysql ubuntu	sql where contains
how to create a table structure from another table in mysql	select nextval from sequence sql	truncate table
install sqlite npm	postgresql check total storage	GROUP BY clause; this is incompatible with sql_mode=only_full_group_by
how to select one row in mysql	select row from mysql where date more than 30 days	sql view where tables have same column name combine results
python mysql check if database exists	drop table if exists	mysql month name extract
SQL SERVER Add Identity Column to existing table	update using case in mysql	No module named MySQLdb
sql count duplicate rows	how to install postgresql on wsl	group_concat limit mysql
sort by sql	query to list all tables in sql database	SELECT User,Host FROM mysql.user;
create a view in sqlite	mysql get last insert id	SQL UPDATE Statement
mysql show table column full description	postgressql uuid	t sql get foreign key

You cant specify target table Person for update in FROM clause

You can't specify target table 'Person' for update in FROM clause -

Comments

0 Comments

More Questions

C

CSS

Objective-C

PHP

Java

C++

Javascript

Html

Python

SQL

Swift

Ruby

Go

R

TypeScript

Kotlin

Assembly

VBA

Scala

Rust

Elixir

Dart

Haskell

Perl

Fortran

Matlab

Scheme

Julia

Lua

Delphi

Pascal

Solidity

BASIC

ActionScript

Csharp